
/*
*Pool Public Licence version 0.1 or later
*Released on 20th April 2008.
*Any voilations can be repoted at paritosh@wikiocean.net
*What is treated as voilations can be found at www.wikiocean.net/ppl1-voilations* 
******************************************************************************
* The contents of this file are subject Affero GPL v3 and later with additional conditions.
* The additional conditions are to be considered as part of the Affero GPL v3 and later.
* The additional conditions will supersede the Affero GPLv3 and later in case of conflict.
* ("License"); You may not use this file except in compliance with the License
* You may obtain a copy of the License at http://www.gnu.org/licenses/agpl.html
* Software distributed under the License is distributed on an "AS IS" basis,
* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for
* the specific language governing rights and limitations under the License.
* The Initial Developer of the Original Code is Paritosh Pungaliya.
* created by Paritosh Pungaliya are Copyright (C) Paritosh Pungaliya; All Rights Reserved.
* Contributions are Copyright (C) 2001-2008 Paritosh Pungaliya.

* Objective of the additional terms (license) 
* 1) Is to extend the software freedom to freedom to work.
* 2) To ensure that knowledge is free from monopoly of agencie(s).
* 3) To avoid a situation where big corporates or investors can buy out free software groups and companies and then start milking the communities built around it.
* (this trend can be seen how the openness changes in companies that get Venture Capital funding.)
* (if you agree to this logic I invite you to our group to work together)

* Additional conditions
*  0) Source code will also include
* 	a) data dictionaries, data ontologies which are used to alter the behavior of code or to control           the features of application.
* 	b) Any code generated or derived automatically or manually from this code or logic
*  1) The revenue generated by deploying, implementing , selling services and other activities
*  	 based on this source code should be shared 100%, between the people working on it.
*  2) Capital invested should be given only fixed rate of return or linked to revenue/surplus growth for limited time.
*  3) People working on the project should always have an option to replace the capital provider in full or part with lower cost capital.
*  4) Their should not be any ownership which can be sold as a claim on future profit to be generated from the work of people working on the code.
*  5) Brand thus generated should belong to the group.
*  6) For old and new members revenue sharing should be equal for same work equivalent.
*  7) The share of revenue should be decided by bidding for work before allocation of work within the group.
*  8) Before bidding various method of measuring the work should be clearly defined and published in public domain. Any change in process should also be publised in public domain imediately.
*  9) All data related to to revenue sharing should be published as and when generated in public domain.
*  10) For group of people having size more than 10 people will have to make it open online for others to participate in bids. 
*  11) All people involved in related and sub project will be treated as a group.
*  12) Once this license is being used for a certain code then all and any other software services being provided by the group should complusorilly come under 100% revenue sharing.
*  13) Cross subsidization should not happen under this revenue share, no additional benefit should be drawn from the people, by the employing agency.
*  14) Any position or knowledge or legal structure created relating to people working on code, which adversely affects the spirit of 100% revenue share will be treated as a violation.
*  15) Revenue sharing defined.
*     a) includes direct revenue and also intangible gains like brand, and organization.
*     b) No personal judgment should be involved in judging the distribution of revenue.It has to be pre-defined formula based.
*     c)100% of revenue should be shared before expenses and recievers should have control over what expenses to incur.
*     d)For the work done in any month by contributing group member, working on any project can be given revenue share from the work done by the group, for a maximum of 18 months after that month.
*     e)Revenue should be apportioned to the month in which work is done and not when received.
*  The group fulfilling the above conditions also has to be a wiki ecosystem further defined in www.wekosystem.org or read about Wekosystem at www.wikiocean.net

*  ******************************************************************************
*/  
package reportoperations;

import java.util.Hashtable;
import java.util.Vector;

import timer.ExecutionTimer;
import timer.TimerRecordFile;
import utility.CapitalChar;
import utility.ConvertToLower;
import utility.Input;
//import file.SearchRecord;
import database.RecordSearch;
import dbmanager.Column;
import dbmanager.DBManager;
import dbmanager.GetIdName;

public class Inword implements Operation
{
	String heading,Inwords,ObjectName;
	DBManager db;
	GetIdName gin;
	String Conversion="Conversion";
	String buffer[];
	StringBuffer strbuffer = new StringBuffer();
	public Setformat format = new Setformat();
	Hashtable<Object,Object> hash = new Hashtable<Object, Object>();
	public void setDatabase(DBManager db)
	{
		ExecutionTimer t = new ExecutionTimer();
		 t.start();
		this.db = db;
		gin = new GetIdName(db);
		Conversion = gin.getId(Conversion);
		t.end();
		TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","setDatabase",t.duration());
	}

	public void setObject(String ObjectName)
	{
		ExecutionTimer t = new ExecutionTimer();
		 t.start();
		this.ObjectName = ObjectName;
		/*String path = Input.MASTERREPORTSPATH+ObjectName+"//"+ObjectName+"_mid"+Input.FILRFORMAT;
		SearchRecord sr = new SearchRecord(path);
		sr.fileOpen();*/
		
		hash.put("mid", ObjectName);
		hash.put("pid", Conversion);
		/*String[] line = sr.getRecordSet(hash);
		sr.fileClose();*/
		
		RecordSearch ps = new RecordSearch(db);
		ps.setConditionMap(hash);
		String[] line = ps.getArrayFromResultSet();
		hash.clear();
		String records[] = {};
		for(int i=0;i<line.length;i++)
		{
			ObjectName = line[i].split("\t")[Column.pv_index-1];
			/*path = Input.MASTERREPORTSPATH+ObjectName+"//"+ObjectName+"_mid"+Input.FILRFORMAT;
			 sr = new SearchRecord(path);
			 sr.fileOpen();*/
			hash.put("mid", ObjectName);
			ps = new RecordSearch(db);
			ps.setConditionMap(hash);
			records = ps.getArrayFromResultSet();
			//records = sr.getRecordSet(hash);
			//sr.fileClose();
		}
		hash.clear();
		for(int i=0;i<records.length;i++)
		{
			 String temp[] = records[i].split("\t");
			 String pid = gin.getItem(temp[Column.pid_index-1]);
			 String pv = temp[Column.pv_index-1];
			 if(pv.equals("0")||pv.equals("no$"))
				 pv = temp[Column.vt_index-1];
			 else
				 pv = gin.getItem(pv);
			 hash.put(pv,pid);
		 }
		t.end();
		TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","setObject",t.duration());
	}
	
	public class  Setformat
	{	 
		
		public void setObject(String object)
		{
			ExecutionTimer t = new ExecutionTimer();
			 t.start();
			/*String path = Input.MASTERREPORTSPATH+object+"//"+object+"_mid"+Input.FILRFORMAT;
			SearchRecord sr = new SearchRecord(path);
			hash.put("mid", object);
			String[] records = sr.getRecordSet(hash);
			hash.clear();
			for(int i=0;i<records.length;i++)
			{
				 String temp[] = records[i].split("\t");
				 String pid = gin.getItem(temp[Column.pid_index-1]);
				 String pv = temp[Column.pv_index-1];
				 if(pv.equals("0")||pv.equals("no$"))
					 pv = temp[Column.vt_index-1];
				 else
					 pv = gin.getItem(pv);
				 hash.put(pv,pid);
			 }*/
				t.end();
				TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","Setformat",t.duration());
		}
		public String setFormat(String Inwords) 
		{
			ExecutionTimer t = new ExecutionTimer();
			 t.start();
			if(Inwords.contains("~"))
				Inwords = Inwords.replace("~", " Rupees and ")+" Paisa Only";
			else
				Inwords = Inwords + " Rupees Only";
			t.end();
			TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","Setformat",t.duration());
			return Inwords;
		}
		public String convertToWords(String number)
		{
			
			ExecutionTimer t = new ExecutionTimer();
			 t.start();
			String Inwords,tempStr="";
			char[] split0Arr,split1Arr;
			String  Words1 ="",Words ="";
			try
			{
				String NUMBER="",digitStr="";
				String[] split = new String[2];
				if(number.contains("."))
				{
					split[0] = number.substring(0, number.indexOf("."));
					split[1] = number.substring(number.indexOf(".")+1);
					split1Arr=split[1].toCharArray();
					String num = split[1];
					if(Long.parseLong(num)>0)
					{	
						if(Long.parseLong(num)<100)
						{
							if(Long.parseLong(num)<10)
							{
								num=num.trim()+"0";
								Words1 =lessThanHundred(num);
							}
							else
								Words1 = Words1 +  lessThanHundred(num);
						}
						else
						{
							for(int y=0;y<split1Arr.length;y++)
							{
								char charDigit;
								int digit;
								charDigit=split1Arr[y];
								digit=Integer.parseInt(""+charDigit);
								digitStr=digitStr.trim()+digit;
								split[1] = number;
								split[1] = String.valueOf(num);
								String number1="",units ="",lastDigit="";
								lastDigit = getUnit(String.valueOf(num));
								try
								{
										units = CapitalChar.makeFirstCharCapital(hash.get(lastDigit).toString());
										num = String.valueOf(num).substring(1);
								}
								catch (Exception e1) 
								{
									digitStr = tempStr.trim()+String.valueOf(num).substring(0, 1);
									if(digitStr.equals("0"))
									{
											digitStr="";
										
									}
									num = String.valueOf(num).substring(1);
									continue;
								}
								try 
								{
									NUMBER =digitStr;
									digitStr="";
									if(NUMBER.equals("0"))
									{
										NUMBER = "";
										number1="";
										continue;
									}
									NUMBER=NUMBER.trim();
									int N=Integer.parseInt(NUMBER);
									if(N>20)
									{
										NUMBER = lessThanHundred(NUMBER);
									}
									else
									{
										NUMBER = CapitalChar.makeFirstCharCapital(hash.get(NUMBER).toString());
									}
									number1 = NUMBER+" "+units+" ";
									System.out.println(number1);
									Words1 = Words1 + number1;
									if(Long.parseLong(num)<100)
									{
										Words1 = Words1 +  lessThanHundred(num);
										break;
									}
									NUMBER = "";
									number1="";
								}
								catch (Exception e1) 
								{
									Words1 = units;
									e1.printStackTrace();
								}
							}
						}
					
						Words1 = "~"+ Words1;
						digitStr="";
					}
				}
				else
						split[0]=number.substring(0);
				
				split0Arr=split[0].toCharArray();
				String num = split[0];
				if(Long.parseLong(num)<100)
				{
					Words = Words +  lessThanHundred(num);
				}
				else
				{
					for(int y=0;y<split0Arr.length;y++)
					{
						char charDigit;
						int digit;
						charDigit=split0Arr[y];
						digit=Integer.parseInt(""+charDigit);
						digitStr=digitStr.trim()+digit;
						split[0] = number;
						split[0] = String.valueOf(num);
						String number1="",units ="",lastDigit="";
						
						
							lastDigit = getUnit(String.valueOf(num));
							try
							{
								System.out.print(hash);
								units = CapitalChar.makeFirstCharCapital(hash.get(lastDigit).toString());
								num = String.valueOf(num).substring(1);
							}
							catch (Exception e1) 
							{
								e1.printStackTrace();
								digitStr = tempStr.trim()+String.valueOf(num).substring(0, 1);
								if(digitStr.equals("0"))
								{
										digitStr="";
									
								}
								num = String.valueOf(num).substring(1);
								continue;
							}
							try 
							{
								NUMBER =digitStr;
								digitStr="";
								if(NUMBER.equals("0"))
								{
									NUMBER = "";
									number1="";
									
									continue;
								}
								NUMBER=NUMBER.trim();
								int N=Integer.parseInt(NUMBER);
							
								if(N>20)
								{
									NUMBER = lessThanHundred(NUMBER);
									
								}
								else
								{
									NUMBER = CapitalChar.makeFirstCharCapital(hash.get(NUMBER).toString());
								}
								
								number1 = NUMBER+" "+units+" ";
								System.out.println(number1);
								Words = Words + number1;
								
								if(Long.parseLong(num)<100)
								{
									Words = Words +  lessThanHundred(num);
									break;
								}
								NUMBER = "";
								number1="";
							}
							catch (Exception e1) 
							{
								Words = units;
								e1.printStackTrace();
							}
					}
				}
				
				Inwords = Words + Words1;
				t.end();
				TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","convertToWords",t.duration());
				return Inwords;
			}
			catch (Exception e) 
			{	
				e.printStackTrace();
				t.end();
				TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","convertToWords",t.duration());
				return "ERROR";
			}
			
			
		
		}
		String lessThanHundred(String num)
		{
			ExecutionTimer t = new ExecutionTimer();
			 t.start();
			num = String.valueOf(Long.valueOf(num));
			String  units ="";
			String  lastDigit="",number1="";
			if(Long.valueOf(num)==0)
			{
				return "";
			}
			if(Long.valueOf(num)<20)
			{
				units = CapitalChar.makeFirstCharCapital(hash.get(String.valueOf(num)).toString());
			}
			else
			{
				try
				{
					number1 = num.substring(0, 1);
					lastDigit = getUnit(String.valueOf(num));
					lastDigit = String.valueOf(Integer.parseInt(lastDigit)*Integer.parseInt(number1));
					units = CapitalChar.makeFirstCharCapital(hash.get(lastDigit).toString());
					lastDigit = num.substring(1);
					if(!lastDigit.equals("0"))
						units = units + CapitalChar.makeFirstCharCapital(hash.get(lastDigit).toString());
				}
				catch (Exception e) 
				{
				}
			}
			t.end();
			TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","lessThanHundred",t.duration());
			return units;
		}
		String getUnit(String num)
		{
			ExecutionTimer t = new ExecutionTimer();
			 t.start();
			int length = String.valueOf(num).length();
			String div = "1";
			for(int i=0;i<length-1;i++)
			{
				div = div+"0";
			}
			t.end();
			TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","setObject",t.duration());
			return div;
		}
	}	
	public static void main(String[] args) 
	{
		
		ExecutionTimer t = new ExecutionTimer();
		 t.start();
		Inword in = new Inword();
		DBManager db = new DBManager();
		db.getConnect();
		in.setDatabase(db);
		GetIdName gid =new GetIdName(db);
		in.setObject(gid.getId("AmountInWords"));
		System.out.println(in.format.setFormat(in.format.convertToWords("1040.00")));
		t.end();
		TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","main",t.duration());
	}

	public void getresult() 
	{
		ExecutionTimer t = new ExecutionTimer();
		 t.start();
		/*String MASTERPATH = Input.MASTERREPORTSPATH + ObjectName + "//" + ObjectName + "_mid" + Input.FILRFORMAT;
		SearchRecord sr = new SearchRecord(MASTERPATH);*/
		Hashtable<Object, Object> table = new Hashtable<Object, Object>();
		table.put("mid", ObjectName);
		table.put("td","null");
		/*sr.fileOpen();
		String line[] = sr.getRecordSet(table);
		sr.fileClose();*/
		RecordSearch ps = new RecordSearch(db);
		ps.setConditionMap(table);
		String[] line = ps.getArrayFromResultSet();
		Hashtable<Object, Object> propertyvector= new Hashtable<Object, Object>();
		
		for(int i=0;i<line.length;i++)
		{
			String splitline[] = line[i].split("\t");
			String value = splitline[Column.pv_index-1];
			if(value.equals("0") || value.equals("no$"))
				value = splitline[Column.vt_index-1];
			else
				value = gin.getItem(value);
			propertyvector.put(gin.getItem(splitline[Column.pid_index-1]), value);
			
			if(splitline[Column.pid_index-1].equals(Conversion))
				ObjectName = splitline[Column.pv_index-1]; 
		}
		/*MASTERPATH = Input.MASTERREPORTSPATH + ObjectName + "//" + ObjectName + "_mid" + Input.FILRFORMAT;
		sr = new SearchRecord(MASTERPATH);*/
		table.clear();
		table.put("mid", ObjectName);
		/*sr.fileOpen();
		line = sr.getRecordSet(table);
		sr.fileClose();*/
		table.put("td","null");
		ps = new RecordSearch(db);
		ps.setConditionMap(table);
		line = ps.getArrayFromResultSet();
		for(int i=0;i<line.length;i++)
		{
			String splitline[] =line[i].split("\t");
			String value=splitline[Column.pv_index-1];
			if(value.equals("0") || value.equals("no$"))
				value = splitline[Column.vt_index-1];
			else
				value = gin.getItem(value);
			propertyvector.put(gin.getItem(splitline[Column.pid_index-1]), value);
		}
		propertyvector = ConvertToLower.convertHashKey(propertyvector);
		int fieldindex=-1;
		String splitbuffer[]=heading.split("\t");
		strbuffer.append(heading);
		if(propertyvector.containsKey("column"))
			strbuffer.append(propertyvector.get("column")+"\t");
		strbuffer.append("\n");
		try 
		{
			for(int j=0;j<splitbuffer.length;j++)
			{
				try 
				{
					if(propertyvector.get("field").toString().toLowerCase().equals(splitbuffer[j].toLowerCase()))
					{
						fieldindex = j;
						break;
					}	
				}
				catch (Exception e) 
				{
					e.printStackTrace();
				}
			}
		}
		catch (Exception e) 
		{
			e.printStackTrace();
		}
		hash = ConvertToLower.convertHashKey(hash);
		for(int i=0;i<buffer.length ;i++)
		{
			splitbuffer= buffer[i].split("\t");
			String value =splitbuffer[fieldindex] ;
			//format.setObject(gin.getId(hash.get("conversion").toString()));
			String valueinword= format.convertToWords(value);
			valueinword= format.setFormat(valueinword);
			if(propertyvector.containsKey("column"))
			{
				buffer[i] = buffer[i] +  valueinword+"\t";
				strbuffer.append(buffer[i]+"\n");
			}	
			else
			{
				splitbuffer[fieldindex] = valueinword;
				for(int k=0;k<splitbuffer.length;k++)
					strbuffer.append(splitbuffer[k]+"\t");
				strbuffer.append("\n");
			}
		}
		
		t.end();
		TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","getresult",t.duration());
	}
	public String[] getbuffer() 
	{
		return strbuffer.toString().split("\n");
	}
	public void setbuffer(String[] buffer) 
	{
		ExecutionTimer t = new ExecutionTimer();
		 t.start();
		this.buffer = buffer;
		t.end();
		TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","setObject",t.duration());
	}
	public void setindexofField(int field) 
	{
	}
	public String getfield() {
				return null;
	}
	public void setHeading(String heading) 
	{
		ExecutionTimer t = new ExecutionTimer();
		 t.start();
		this.heading = heading;
		t.end();
		TimerRecordFile timerFile=new TimerRecordFile("reportoperations","Inword","setHeading",t.duration());
	}
}

